<?php
(!defined('IN_TOA') || !defined('IN_ADMIN')) && exit('Access Denied!');
/*
	[天生创想] (C)2008-2011 515158 Inc.
	This is NOT a freeware, use is subject to license terms
    URL:http://www.515158.com/
*/

get_config_keytable("book_key");

function get_inc_user_types($fid=0)
{
    global $db;
	$html='';
	$query = $db->query("SELECT title FROM ".DB_TABLEPRE."book_type where id='".$fid."' ORDER BY id desc limit 0,1");
	while ($rowuser = $db->fetch_array($query)) {
	$html .= $rowuser[title];
	}
	return $html;
}



empty($do) && $do = 'list';
if ($do == 'list') {
	//列表信息 
	$wheresql = '';
	$page = max(1, getGP('page','G','int'));
	$pagesize = 20;
	$offset = ($page - 1) * $pagesize;
	$url = 'admin.php?ac=file_read_key&fileurl=book';
	if ($type = getGP('type','G')) {
		$wheresql .= " AND type ='".$type."'";
		$url .= '&type='.$type;
	}
	$num = $db->result("SELECT COUNT(*) AS num FROM ".DB_TABLEPRE."book_read  WHERE 1 $wheresql ORDER BY id desc");
    $sql = "SELECT * FROM ".DB_TABLEPRE."book_read WHERE 1 $wheresql ORDER BY id desc LIMIT $offset, $pagesize";
	$result = $db->fetch_all($sql);

	include_once('template/file_read_key.php');

} elseif ($do == 'save') {
	$tid = getGP('tid','G');
	$ltype = getGP('ltype','G');
	$r = $db->fetch_one_array("SELECT * FROM ".DB_TABLEPRE."book_read where id='".$tid."' ORDER BY id desc limit 0,1");
	$book = array(
		'type' => $ltype
		
	);
	update_db('book',$book, array('id' => $r[bookid]));
    
	$book_read = array(
		'type' => $ltype,
		'examperson' => $_USER->id,
		'examdate' => get_date('Y-m-d H:i:s',PHP_TIME)
	);
	update_db('book_read',$book_read, array('id' => $tid));
    $content=$ltype;
	$title='图书审批';
	get_oa_log_dbadd($tid,$content,$title,22,$_USER->id);
   goto_page('admin.php?ac=file_read_key&fileurl=book&type='.getGP('type','G').'');

} elseif ($do == '删 除') {
get_config_keytable("book");
	
	$idarr = getGP('id','P','array');
	foreach ($idarr as $id) {
	$db->query("DELETE FROM ".DB_TABLEPRE."book_read WHERE id= '$id'");
	$content=$id;
	$title='删除图书借阅信息';
	get_oa_log_dbadd($id,$content,$title,22,$_USER->id);	
	}
    goto_page('admin.php?ac=file_read_key&fileurl=book&type='.getGP('type','P').'');

}
?>